from sqlalchemy import Column, Integer, String, Boolean, DateTime, text
from datetime import datetime
from config.Database import Base

class SignApplyInfo(Base):
    __tablename__ = "sign_apply_info"

    id = Column(Integer, primary_key=True, autoincrement=True)
    nickName = Column(String(20))
    username = Column(String(30))
    password = Column(String(30))
    email = Column(String(30))
    activityId = Column(String(20))
    activityName = Column(String(30))
    signType = Column(Integer, comment='1是签到 2是签退')
    signTime = Column(Integer)
    createAt = Column(DateTime, server_default=text('CURRENT_TIMESTAMP'))
    isApply = Column(Integer, default=0, comment='0就是没有申请 1就是已申请')
    remark = Column(String(255))
    isSuccess = Column(Integer, default=0)
    isDelete = Column(Integer, default=0)
    isPush = Column(Integer, default=0)
